Skip Headers

Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DROP ROLE

Purpose

Use the `DROP` `ROLE` statement to remove a role from the database. When you drop a role, Oracle Database revokes it from all users and roles to whom it has been granted and removes it from the database. User sessions in which the role is already enabled are not affected. However, no new user session can enable the role after it is dropped.

See Also: CREATE ROLE and ALTER ROLE for information on creating roles and changing the authorization needed to enable a role SET ROLE for information on disabling roles for the current session

Prerequisites

You must have been granted the role with the `ADMIN` `OPTION` or you must have the `DROP` `ANY` `ROLE` system privilege.

Syntax

drop_role::=

Description of the illustration drop_role.gif

Semantics

role

Specify the name of the role to be dropped.

Example

Dropping a Role: Example To drop the role `dw_manager`, which was created in "Creating a Role: Example", issue the following statement:

    DROP ROLE dw_manager;